Dashboard 03 and 04 - Year Over Year (YOY) Total Properties & Total Sales by Township Scrollers 16



Next, we will create a Year Over Year (YOY) Total Properties & Total Sales by Township Scroller


Step 1 - Download Scroller Visual in the ZipCode dashboard

In Power BI Desktop, click on the page, ZipCode .

If you don't see the Scroller Visualizations under Visualizations, follow these steps to add it.


Under Visualizations, click on the Ellipsis  (...) ->  Import a Visual from a file ->  browse to the extracted folder ->  WakeCounty_Real_Estate_Property_Template and select Scroller.2.0.3.0.pbiviz


Note: Alternatively, you can download it from the AppSource.

To import a Scroller visual from AppSource, in the Visualizations pane, click on the Ellipsis  (...), select the Get more visuals icon and then select Get more visuals. On the window that displays, locate (search) and select the Scroller visual that you want to import and then select Add.












Step 2 - Create Year Over Year (YOY) Total Properties by Township Scroller

Visualizations

Click the Scroller icon



Fields

Select the following:

Township ->  Township_Name - Under Visualizations, drag & drop it in the Category section

A_KeyMeasures ->  .Total_Properties  - Under Visualizations, drag & drop it in the Measure Absolute section.

A_KeyMeasures ->  .YOY_Total_Properties%  - Under Visualizations, drag & drop it in the Measure Deviation section.





Visualizations


Fields tab

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the fields as follows:

.Total_Properties = Total Properties

.YOY_Total_Properties% = YOY Total Properties

Township_Name = Township Name






Format tab

To format the visual, beneath the Visualizations pane, select the Format pane.


Under Format ->  General: X Position = 362 , Y Position = 1029 , Width = 1134 , Height = 52

Under Format ->  Scroller -> Auto-size font = OFF , Set Status Indicator to ON ->  Font Size = 18 , Scroll Speed = 1 , TextColor = #FFFFFF , Background Color = #1D0C4A , Update Interval = 50

Under Format -> Title ->  Set it to ON , Title Text = Year Over Year (YOY) Total Properties by Township , Font Color = #1D0C4A , Background Color = #E6E6E6 , Alignment = Center , Text Size = 16 pt , Font Family = DIN (Default)

Under Format ->  Background ->  Set it to OFF

Under Format ->  Border ->  Set it to ON , Color = 666666, Radius = 5 px



Filters

None




Sort the Scroller by Township name in ascending order

Click on the Ellipsis  (...), select Sort by = Township.
Click on the Ellipsis  (...), select Sort ascending.




Step 3 - Create Year Over Year (YOY) Total Sales by Township Scroller in the Township dashboard



Visualizations

To create the following visual, copy and paste the Year Over Year (YOY) Total Properties by Township Scroller that was created in Step 2 and use it as a template.


To create a copy of the visual, click the Year Over Year (YOY) Total Properties by Township Scroller visualization , Click on the Township dashboard , press Ctrl+C to copy, and then press Ctrl+V to paste




Fields

Select the following:

Township ->  Township_Name - Under Visualizations, drag & drop it in the Category section

A_KeyMeasures ->  .Total_Sales_Properties  - Under Visualizations, drag & drop it in the Measure Absolute section.

A_KeyMeasures ->  .YOY_Total_Sales_Properties%  - Under Visualizations, drag & drop it in the Measure Deviation section.





Visualizations



Fields tab

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the fields as follows:

.Total_Sales_Properties = Total Sales

.YOY_Total_Sales_Properties% = YOY Total Sales

Township_Name = Township Name






Format tab

To format the visual, beneath the Visualizations pane, select the Format pane.


Under Format ->  General: X Position = 362 , Y Position = 1028 , Width = 1149 , Height = 52

Under Format ->  Scroller -> Auto-size font = OFF , Set Status Indicator to ON ->  Font Size = 18 , Scroll Speed = 1 , TextColor = #FFFFFF , Background Color = #1D0C4A , Update Interval = 50

Under Format -> Title ->  Set it to ON , Title Text = Year Over Year (YOY) Total Sales by Township , Font Color = #1D0C4A , Background Color = #E6E6E6 , Alignment = Center , Text Size = 16 pt , Font Family = DIN (Default)

Under Format ->  Background ->  Set it to OFF

Under Format ->  Border ->  Set it to ON , Color = 666666, Radius = 5 px



Sort the Scroller by Township name in ascending order

Click on the Ellipsis  (...), select Sort by = Township.
Click on the Ellipsis  (...), select Sort ascending.



Filters

None


It will look as follows when complete:








For more information on the Scroller or to download the Scroller used in this project:


Scroller